<?
require("config.php");
require("header.php");
?>



<?
$showNewsletters = true;



?>









<table width="100%" border="0" align="center" cellpadding="0" cellspacing="0">
  <tr> 

    <td width="186" valign="top"> 
      <?require("nav.php")?>
    </td>
    <td width="11"><img src="images/shim.gif" width="11" height="1"></td>
    <td valign="top"> 
      <?require("menu.php")?>
      <table width="100%" border="0" cellspacing="0" cellpadding="0">
        <tr> 
          <td align="right"><table width="100%" border="0">
              <tr> 
                <td height="50" class="header">&gt;&gt; Archives of Acuity World Newsletters</td>
              </tr>
            </table></td>
        </tr>
      </table>
      <br> 
			<?

$table = "med_newsletter";

$field = array(

"id",
"date",
"subject",
"pdf",
);

$exp = "and type='Denmark' ORDER by date desc";


$r = unlimitQuery($table,$field,$exp);

?>
      <strong>Archives of Newsletters:</strong>			
      <table width="100%" border="0" cellspacing="0" cellpadding="0">
			
            <tr>
              <td>&nbsp;</td>
              <td>&nbsp;</td>
            </tr>
            <tr>
              <td><strong>Denmark</strong></td>
              <td>&nbsp;</td>
            </tr>
            <tr>
              <td>&nbsp;</td>
              <td>&nbsp;</td>
            </tr>
			<?php for ($i=0;$i<count($r);$i++) { 
			$download = "../pictures/med_newsletter/" . $r[$i][3];
			?>
        <tr>
          <td width="16%"><strong>
             <a href="javascript:Redirect('<?=$download?>',5)"><?=date("M Y", mktime(0,0,0,substr($r[$i][1], 5, 2),substr($r[$i][1], 8, 2),substr($r[$i][1],0,4)))?></a>
          </strong></td>
          <td width="84%"><strong>
            <a href="javascript:Redirect('<?=$download?>',5)"><?=$r[$i][2]?></a>
          </strong></td>
        </tr>
		
		<?php } ?>
        <tr>
          <td>&nbsp;</td>
          <td>&nbsp;</td>
        </tr>
        <tr>
          <td><strong>Hong Kong</strong></td>
          <td>&nbsp;</td>
        </tr>
		<tr>
              <td>&nbsp;</td>
              <td>&nbsp;</td>
            </tr>
		<?

$table = "med_newsletter";

$field = array(

"id",
"date",
"subject",
"pdf",
);

$exp = "and type='Hong Kong' ORDER by date desc";


$r = unlimitQuery($table,$field,$exp);
 for ($i=0;$i<count($r);$i++) { 
 $download = "../pictures/med_newsletter/" . $r[$i][3];
			
?> 
        <tr>
          <td width="16%"><strong>
             <a href="javascript:Redirect('<?=$download?>',5)"><?=date("M Y", mktime(0,0,0,substr($r[$i][1], 5, 2),substr($r[$i][1], 8, 2),substr($r[$i][1],0,4)))?></a>
          </strong></td>
          <td width="84%"><strong>
            <a href="javascript:Redirect('<?=$download?>',5)"><?=$r[$i][2]?></a>
          </strong></td>
        </tr>
		
		<?php } ?>
			
      </table>
      <p>          <br> 
        <br>
        <br> 
      </p>
    </td>
    <td width="11"><img src="images/shim.gif" width="11" height="1"></td>
    <td width="173" valign="top">
	
	
<?require("list.php")?>	 
	  
	  
    </td>

  </tr>
</table>





<?require("footer.php")?>	